package com.sg.dao;

import com.sg.pojo.ExamResult;
import com.sg.pojo.Grade;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author shkstart
 * @creat 2022-05-14:26
 */
public interface ExamResultMapper {
    //查看所有考试信息
    List<ExamResult> findAll();
    List<ExamResult> findExam();

    //插入新考试
    int addExam(ExamResult examResult);
    //分页查询
    List<ExamResult> findExamByLimit(@Param("pageNo")int pageNo, @Param("pageSize")int pageSize);
    //查询考试总数
    int findTotal();
    //根据编号查找考试信息
    Grade findExamResult(long id);
    //根据编号修改考试信息
    int updateExamResult(ExamResult examResult);
    //根据编号删除考试信息
    int delExamResult(long id);


}
